﻿CREATE TABLE [dbo].[InvoiceMaster] (
    [InvoiceNo]     VARCHAR (30)    NOT NULL,
    [CustomerNo]    VARCHAR (8)     NOT NULL,
    [VendorNo]      VARCHAR (8)     NOT NULL,
    [ProductAmount] NUMERIC (15, 2) NULL,
    [TaxAmount]     NUMERIC (15, 2) NULL,
    [InvoiceDate]   DATETIME        NOT NULL,
    [Recipient]     VARCHAR (20)    NOT NULL,
    [Review]        VARCHAR (20)    NOT NULL,
    [Drawer]        VARCHAR (20)    NOT NULL,
    [ReferenceNo]   VARCHAR (30)    NULL,
    [Remark]        VARCHAR (60)    NULL,
    [InvoiceType]   INT             NOT NULL,
    [RecordID]      INT             IDENTITY (1, 1) NOT NULL
);

